package com.constants;

public class StringCons {
	
	public static final String INSERT_SQL =  "insert into jiankong_data_info_table(msg,dial,location,controlled_id,id) values(?,?,?,?,jiangkong_data_info_table_seq.nextval )";
	
	public static final String SELECT_SQL = "select msg,dial,controlled_id,location,id from db.jiankong_data_info_table where controlled_id = ? and type ='new'";
	
	public static final String CHANGE_OLD_TO_NEW = "update db.jiankong_data_info_table set type = 'old' where id = ?";
	
	public static final String CHECK_SQL = "select state db.from jiankong_account_table where userid = ?";
	
	public static final String ADMIN_LOGIN_SQL = "select userid from db.jiankong_admin_account_table where userid = ? and pwd = ?";
}
